SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 40
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Escape to your own slice of paradise with this stunning 3-bedroom, 2.5-bath home offering breathtaking, expansive views! Nestled on 21 acres of picturesque land, this property is perfect for nature lovers, hobby farmers, or anyone seeking tranquility while still being close to Dartmouth, schools, shopping, restaurants. Enjoy the perfect blend of modern comfort and outdoor living with an attached garage, a spacious barn, and miles of trails right outside your door.The master suite is a spacious retreat with a private bath and walk in closet while the two additional bedrooms offer ample space for family, guests, or a home office with hi speed internet. The open living and dining areas feature large windows that bring the scenic surroundings indoors, creating a bright and welcoming atmosphere.Enjoy the fireplace warmth as you watch the wildlife through the many windows.Additional features include an attached 2-car garage for secure parking and storage, as well as a barn that's perfect for animals, equipment, or hobbies. The expansive 21 acres includes fields and trails, providing endless opportunities for outdoor recreation, whether it’s hiking, horseback riding, cross country skiing, snowmobiling,or just enjoying the peaceful surroundings.**The 126 acre abutting lot is also available for sale. See MLS#5027346. Some photos are virtually staged.
Description:Bring you chickens, your green thumb and your swim suit and enjoy everything this 3.2+/- acre property has to offer approx. 15 minutes from Dartmouth College and Dartmouth Health! This 3-4 bedroom, 2.5 bedroom home features charming exposed beams, open eat-in kitchen/dining room with a wood fireplace, cozy living room with reading nook and a wood stove for those chilly winter nights, a patio leading to a screened porch, garden space, multiple outbuildings and a swimming and skating pond! This home has something for everyone including a trail network within walking distance and Trescott trail access off of Dogford Rd. for mountain biking about 3 miles away. Do you love to ski? The Dartmouth Skiway is approx. 15 minutes as well! What a spot! Delayed showings start at the Open House on Saturday, Feb 15 from 11:00-1:00. Note - Town has it listed as a 3 bedroom so we assume it's a 3 bedroom septic.
Description:This light-filled, contemporary home with 3 bedrooms and 2.5 baths is situated in a highly desirable cul-de-sac located mere minutes from downtown Hanover and Dartmouth College. The kitchen opens into a bright dining area with cathedral ceiling. A sunbathed living room with fireplace, a cozy family room and a home office complete the first floor. The primary bedroom with ensuite bathroom, as well as two nicely sized bedrooms and a full bath comprise the second floor. Enjoy the options of a finished basement with natural light. The outdoor space is highlighted by a great back deck overlooking a cleared backyard. Further outdoor enjoyment awaits at Storrs Pond Recreation Area and trail network- just a mile away. A terrific home in premier neighborhood and location! The office photo is virtually staged. SHOWINGS BEGIN FRIDAY, 3/28/25.
Description:Convenient location, optional 1-floor living, and extensive, thoughtful updates come together in this fully move-in ready home. The main floor includes a large and inviting kitchen with newer stainless steel appliances including a double oven and Wolf range, Crown Point cabinetry, and marble countertops, a separate dining room, living room with fireplace, 2 bedrooms that share a full bath, plus a primary bedroom with updated 3/4 en-suite bath. The lower walkout level features another bedroom, full bath, large playroom or den with Hearthstone wood stove, office space, laundry and workshop, plus plenty of extra storage space. Outside you'll find a newly resurfaced Trex deck from which there are lovely seasonal mountain views, a fenced yard with raised garden beds and mature plantings, and a paved circular drive. Recent updates are numerous and a full list is available on request but energy efficiency was a priority. A fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater, a Level-2 CCS EV charger and Anderson 400 Low-E windows are some highlights. Located almost equidistant to Dartmouth College, DHMC, West Lebanon, and the Miracle, commuting and shopping are a breeze. SHOWINGS BEGIN AT OPEN HOUSE SATURDAY, APRIL 26 10:30-1:30.
Description:Come to Etna and make your new home on Dogford Road. This contemporary home has it all. From a large open kitchen/living/dining room combination family and guests can disperse to any number of getaways in this multi level home. Enjoy the abundant wildlife, songbirds, hooting owls, and a crows nest where you can escape amongst the trees. Two bedrooms, a full bathroom and workout area complete the lower walk out area. The main floor has a vaulted ceiling along with a generous full length deck. Enjoy great natural light from all levels of this home. The house sits up high so you really feel the privacy afforded by the trees, particularly at the rear. The primary bedroom is oversized and and has it's own ensuite bathroom. The other bedroom on this level is served by a three quarter bath and then via a spiral stairwell you can escape the madding crowd and vanish up to the aforementioned crows nest with it's little balcony. Read, craft, nap-whatever-this is a really cool space. The 4.2 acres is mixed with some wetlands at the back, some very nice terracing near the house and also blueberry bushes are a plenty. This is a really lovely property and could be your next home. Come and check out 420 Dogford Road you won't be disappointed. Delayed showings begin with an Open House on Saturday April 26th, 2025 between 11:00 AM - 1:00 PM.